SELECT 
c.category_id categories_id,
c.parent_id,
c.sort_order,
d.language_id,
d.name categories_name,
p.product_id products_id


from 
<@PREFIX>product_to_category p join 
<@PREFIX>category c on (p.category_id = c.category_id) join 
<@PREFIX>category_description d on (p.category_id = d.category_id)

where 
d.language_id = %s